Join problem

[GinsBabu]

Hi,

 

i do have a join query for 2 tables.i want to display a field as null if it is NULL.how can i do that?Also i have a where condition.what if i want to select value from first table even if the where condition is not satisfied.

[GinsBabu]

Hi,

 

i do have a join query for 2 tables.i want to display a field as null if it is NULL.how can i do that?Also i have a where condition.what if i want to select value from first table even if the where condition is not satisfied.Mysql version is 5.1

[gevensen]

download toad its free and has a query builder that makes those complex statements

[kickstart]

Hi

 

For the first part, try something like this:-

 

SELECT *, if(b.id IS NULL, 'null',b.id) 
FROM table1 a 
LEFT OUTER JOIN table2 b
ON a.id = b.PageId

 

Not sure what you want with a WHERE clause that is ignored.

 

All the best

 

Keith