special left join 1

[andreas57]

im using following statement:

select $tblL.*,$tblT.desc,$tblT.text from $tblL left join $tblT using(id$tblL) where id$tblLang=2 || id$tblLang is null order by position

my problem is that the the enties from the 1. table aren't displayed if there is no entry in the 2. table eventhough i set the condition "|| id$tblLang is null". how can i do this with one statement?

andreas owen

 

[r937]

could you please substitute your variables and show us the actual query as passed to the database?

also, if you have columns in the WHERE clause, please indicate which table they're in

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[andreas57]

sorry, the variables are irrelevant (hwo could you know) but the 2. question is important, here's the query:

select tblL.*,tblT.desc,tblT.text from tblL left join tblT using(idtblL) where idtblLang=2 || idtblLang is null order by position

idtblLang is in the 2 table (tblT)


andreas owen

 

[r937]

select tblL.*
     , tblT.desc
     , tblT.text 
  from tblL 
left outer
  join tblT 
    on tblL.idtblL = tblT.idtblL
   [b]and[/b] idtblLang = 2
order 
    by position

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)