|
|
Posted by abighill on 10/03/60 11:41
Hi noone,
I tried your suggested SQL query and phpMyAdmin returned:
MySQL said:
#1054 - Unknown column 'a.data_id' in 'where clause'
This is because the 'data_id' does not exist in 'fett_url a' so I
changed the SQL query to read:
SELECT a.url_id,
a.url_title,
a.url_link,
a.url_description,
b.url_id,
b.data_id
FROM fett_url a
LEFT OUTER JOIN fett_url_to_data b
ON a.url_id = b.url_id
WHERE b.data_id = 2
and b.url_id is null
ORDER BY a.url_title
This time the query ran successfully but nothing was returned.
Navigation:
[Reply to this message]
|