SQL queries across two tables
Last Post 11/06/2014 12:33 PM by Amanda Thomas. 2 Replies.
Author Messages
Amanda Thomas
Nuke Pro
Nuke Pro
Posts:73


--
10/27/2014 2:30 PM  
I am just becoming familiar with SQL, particularly using SQL queries to administer my DNN site.

I would love to run a script that would copy a module to all pages IF the pages were using a specific skin.

Something to the effect of "copy this module to the sidepane in all pages that HAVE a sidepane" would work too.

I'm just not sure how since this information (all info in TabModules, then page skin assignments which are in Tabs) spans two tables.

Any help? Thanks!
laxmi pandey
Nuke Active Member
Nuke Active Member
Posts:23


--
11/01/2014 7:05 AM  
hi Amanda
not getting your question please explain more
Amanda Thomas
Nuke Pro
Nuke Pro
Posts:73


--
11/06/2014 12:33 PM  
Hi!

I figured it out since then. I mastered the JOIN function!


---