Mismatch error

[gusc999]

I have to two tables one has 2800 records the other one has 166 records. I have to join the tables by the item field. The 166 record table has duplicate item numbers which are need. When I create the join I get a mismatch error. I tried the left and right joins but it doesn't work. Can someone help me on identifing what is casuing the mismatch.

SELECT RPT0092_ISP_AS400SQL_SlotItem.Item AS RPT0092_ISP_AS400SQL_SlotItem_Item, WedsFlags.ITEM AS WedsFlags_ITEM
FROM WedsFlags LEFT JOIN RPT0092_ISP_AS400SQL_SlotItem ON WedsFlags.ITEM = RPT0092_ISP_AS400SQL_SlotItem.Item;

 

[GingerR]

Mismatch error is usually because you are trying to join number to text fields, or double to long or something.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[lespaul]

gus,
you may also be interested in Understanding SQL Joins.

Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com