but I have never had to do this ....
I have two tables
Table 1: PAGES
Table 2: MAIN
PAGEShas records: page_id, text
MAIN has records: item_id, page_no, stuff
Now ALL the page_no's on MAIN refer to page_id's of records on PAGES
But not all pages on PAGES are on the MAIN table.
So how do I check for records that are NOT on MAIN ??
Would it be this ?
$sql = "SELECT pages.* FROM pages,main WHERE pages.page_id != main.page_no ";
Seems wrong somehow
Instead of "not equal" I really want it to say "not existing" on main
Thanks for any help.
If you want to attract and keep more clients, then offer great customer support
automates the process and gives you a trust seal
to place on your website.
I recommend that you at least take the 30 day free trial