|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
mysql error(ambiguos column)
hi everyone i'm new to this forum and i've been trying to solve this problem for some days now .i trying to retrieve data from a join query based on certain conditons but keep getting an mysql error. the query is shown below:
select c.Sender,c.Subject,c.Message,c.date,c.Time,m.Recip ient from co_messages as c,mess_link as u,mess_Recipient as m where c.id=u.co_id and m.id=u.id and Sender='gkanu'; Query Failed: Column 'Sender' in where clause is ambiguous |
|
#2
|
|||
|
|||
|
The db doesn't know what table to look for Sender in -- you need to label it with the alias of the proper table like the other column references:
Code:
WHERE x.Sender = 'gknau'
__________________
"A pawn is the most important piece on the chessboard -- to a pawn" |
|
#3
|
|||
|
|||
|
thanks i sorted that out.
|
![]() |
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > mysql error(ambiguos column) |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|