i have 2 common fields between 2 tables without using composite key i want make all fields as a single field ?how?

[#1]

i have 2 common fields between 2 tables without using composite key i want make all fields as a single field ?how?

[Anonymous]

You can concatenate both tables to make common fields as a single field.

[avinashelite]

Hi Manoj,

If the data is less you can concatenate the tables, otherwise use the link table to connect the two tables.

Regards,

@vi