select all that are a NULL

[poe]

how do i select items from a database that are a NULL

 

i have:

$qxs = " SELECT l.ID, l.TITLE, l.FEATURED, l.LINK_TYPE, l.EXPIRY_DATE, p.LINK_ID, p.QUANTITY, p.PAY_DATE ";
$qxs .= " FROM `tbl_link` = l, `tbl_payment` = p ";
$qxs .= " WHERE p.LINK_ID = l.ID ";
$qxs .= " AND l.EXPIRY_DATE = NULL ";
$result = mysql_query( $qxs );

 

but shows 0 results...

 

if i drop the " AND l.EXPIRY_DATE = NULL ";

 

this gives me results.

[bubblegum.anarchy]

The problem is:

 

FROM `tbl_link` = l, `tbl_payment` = p 

 

should be:

 

FROM `tbl_link` AS l, `tbl_payment` AS p 

[Wildbug]

It's the =NULL.  It should be "IS NULL".

 

...AND l.EXPIRY_DATE IS NULL

 

I'm surprised, but the "tbl_link = l" does work.  You don't need the "=", but bg.anarchy is right that it's usually "AS".  Anyway, you can alias without either.

 

...FROM tbl_link l, tbl_payment p...

[bubblegum.anarchy]

yeah, that to.