type mismatch

[Drew]

I have the following sql statement

SELECT UTADBA_PARCEL.PARCEL_ID, UTADBA_PARCEL.LINK_ID
FROM Serial INNER JOIN UTADBA_PARCEL ON Serial.[Parcel ID] = UTADBA_PARCEL.PARCEL_ID;

I know that it is a type mismatch because Serial.[Parcel ID] is a number and UTADBA_PARCEL.PARCEL_ID is a text

I wrote all of this using tables on my database and it worked fine, but i had to switch them out for link tables before it could be used. I know that there is a way to put quotes around a part to make it function as text, i don't know how or where though. I tried putting quotes on like this

SELECT UTADBA_PARCEL.PARCEL_ID, UTADBA_PARCEL.LINK_ID
FROM Serial INNER JOIN UTADBA_PARCEL ON "Serial.[Parcel ID]" = UTADBA_PARCEL.PARCEL_ID;

this is the only way it does not give me a syntax error but it does say "JOIN expression not supported"

If anyone could help me with this it would be greatly appreciated.

 

[Golfinray]

Try changing to "utadba_parcel.parcel_id"