Master detail relationship

[krishnaroopa]

Hi

I am using QV 11, with data from sql 8.

In sql8, I have 2 tables:

1. shipment with columns - dbsource, id, shipdate amt

2. charges with columns - dbsource, id, code, amt

Charges table has the split up of charges for individual shipments

To load the data from these tables, i used left keep and had the data loaded

//QVTab1:

//Select * from Table1;

//QVTab2:

//left keep select * from Table2;

But it results in synthetic key table, how can this be avoided?

Thanks

KRS

[hallquist_nate]

Alias the columns that are joining, that shouldn't be.  I like to qualify the tables, like "SourceTable.FieldName".

Nate

[#3]

with Qualify *;

[#4]

Hi Krishnaroopa,

May be your tables have more then 1 field common in both. so please alias the columns. There can be only 1 common field in both tables to complete data modal.

Hope it will help you.

Regards

-Anil

[krishnaroopa]

yes, I have 2 columns in common, that is required to join the table / select the record,

I cannot change that, what can be done?

regards

KRS

[#6]

Hi, Will you post your script along with column's name. In your first post you used * in script insted of * use column names (All column) and post.

Then only I can suggest some thing

Regards

Anil