Run Query generates SQL without a JOIN

Z

zeon

I have a IP 2003 form that connects to an SQL 2005 database. The table
contains a parent table and a 1 child table, related by a foreign key
relationship. The primary key of the parent and child are generated numbers,
using the SQL "Is Identity" with a seed of 1.

The issue is that if I query on anything but the primary key of the parent,
and that query returns multiple rows, the query rusults in a cartesian
product, in that the query will return the data from only 1 row in the parent
table, and associate that with all the rows in the child table.

I think if the query used a JOIN this would not occur, however, I've been
unsuccessful in modifying the generated SQL to do this - I keep getting
syntax errors. My goal is to do this without custom code.

Any help would be appreciated. Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Linking Child Timelines to Multiple Parents 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Can I save a sql statement generated by a search form? 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Creating a Chart on form from selected data in query. 0
SQL self join 2
query data from a parent-child table 1

Top