sql query for importing database

[Rishali]

Hi,

I am using an ODBC connector for importing an external mysql database. i wrote sql select query for that ....i am having problem with one of the table.

In the address table form mysql database having address_id and customers _id in this eg. address_id = 1 and customers_id =1 for shipping address And address_id = 2 and customers_id =1 for billing address so there will be always two rows with same customers_id ...... now i want to import this kind of data into filemaker but while importing in FM it is not taking same id number only once it is taking....

Please suggest solution for this