#1054 - Unknown column 'xxxx' in 'on clause'

[rcouser]

Hi,

Get an unknown column error but the code looks fine, wondering if someone else can see anything i'm missing:

 

Table: returns

id (primary)

reference

account_number

 

Table: returns_items

id (primary)

returns_id

qty

gas_type

SELECT *
FROM returns t1
LEFT JOIN returns_items t2 ON t1.id = t2.return_id
WHERE (t1.order_date >= '2013-08-01')

Any help much appreciated.

[gristoi]

youve got return_id in your query and returns_id in your table structure ( missing s)

[rcouser]

sorry that was my typo.it is return_id

[gristoi]

what is the exact error. unkown xxxxx is not too helpful. is it actually giving you a column name? and where is order_date in the t1 structure?

[rcouser]

Error is:

#1054 - Unknown column 'returns.id' in 'on clause'

 

And yes sorry order_date is in the returns table, i forget that when typing my message

[mac_gyver]

programming is an exact science. so far in this thread, your table definition, query, and error message don't match up and due to typos on your part no one here knows which name for the column is correct.

 

you should be copy/pasting actual information if you want someone in a help forum to be able to help you.

[rcouser]

Table: returns

---

id (primary)

reference

account_number

order_date

 

Table: returns_items

---

id (primary)

return_id

qty

gas_type

SELECT *
FROM returns t1
LEFT JOIN returns_items t2 ON t1.id = t2.return_id
WHERE (t1.order_date >= '2013-08-01')

Error is:

#1054 - Unknown column 'returns.id' in 'on clause'

[mac_gyver]

that error message is coming from some other query.

[rcouser]

SELECT *
FROM returns t1
LEFT JOIN returns_items t2 ON t1.id = t2.return_id
WHERE (t1.order_date >= '2013-08-01')

OR

SELECT *
FROM returns t1
LEFT JOIN returns_items t2 ON returns.id = returns_items.return_id
WHERE (t1.order_date >= '2013-08-01')

Same error only the unknown column 'returns.id' changes.

If I change it to:

SELECT *
FROM returns t1
LEFT JOIN returns_items t2 ON returns_items.return_id = returns.id
WHERE (t1.order_date >= '2013-08-01')

The unknown column becomes 'returns_items.return_id'

[Barand]

If you alias the tables you need to reference their column using that alias

 

returns.id should be t1.id