Jerry
|
Posted: 06/04/2003, 11:05 AM |
|
This is more of a query question then a ccs question, but again, I am
stumped... I am using access.
I have 2 tables that I need to show a record from where they have a matching
field.
Both table A and table B have the field inventory_id, so I need to show the
records that both tables have the same inventory_id
Here is my query:
SELECT bids.bid_id, bids.bid_number, bids.bid, bids.inventory_id,
bids.table_item_number, inventory.inventory_id, inventory.name,
inventory.description, inventory.image, inventory.cost,
inventory.selling_price, inventory.room, inventory.row, inventory.shelf,
inventory.category, inventory.qty, inventory.date_rec
FROM inventory INNER JOIN bids ON inventory.inventory_id = bids.inventory_id
WHERE (([ bids].[inventory_id]=[inventory].[inventory_id]));
When I try it like this I get a type mismatch in expression error.
I need to run this query for a report then I need to append that query to
another table.
Does anything stick out that is wrong?
Thanks for the help,
Jerryb
|
|
|
Jerry
|
Posted: 06/04/2003, 1:01 PM |
|
Nevermind, got it...
Thanks anyway
"Jerry" wrote in messagenews:bblcce$r2b$1@news.codecharge.com...
> This is more of a query question then a ccs question, but again, I am
> stumped... I am using access.
>
> I have 2 tables that I need to show a record from where they have a
matching
> field.
>
> Both table A and table B have the field inventory_id, so I need to show
the
> records that both tables have the same inventory_id
>
> Here is my query:
>
> SELECT bids.bid_id, bids.bid_number, bids.bid, bids.inventory_id,
> bids.table_item_number, inventory.inventory_id, inventory.name,
> inventory.description, inventory.image, inventory.cost,
> inventory.selling_price, inventory.room, inventory.row, inventory.shelf,
> inventory.category, inventory.qty, inventory.date_rec
> FROM inventory INNER JOIN bids ON inventory.inventory_id =
bids.inventory_id
> WHERE (([ bids].[inventory_id]=[inventory].[inventory_id]));
>
> When I try it like this I get a type mismatch in expression error.
>
> I need to run this query for a report then I need to append that query to
> another table.
>
> Does anything stick out that is wrong?
>
> Thanks for the help,
> Jerryb
>
>
|
|
|
|