Hello
I have a question...
i have 4 tables
location table (locationid ,address1 address2)
exception table( idcol1,locationid,createdby)
table1 (locationid,idcol1)
look up table -- idcol1 firstname lastname
exception table will be populated only for exceptions for that location
so this case i need to join between location table exception table and look up table
otherwise i need to join
location table ,table1 and look up table
i have other tables as well to join before these table to get to these tables
location table left join table 1 on location id
left join exception table on locationid
left join on look up table on isnull(idcol1,table1.idcol1) = lokup table.idcol1
does this sound right?