I have two table " invoice detaisl"and "payments details"I need to join both table with the coulumn name is "INVOICE_ID" is coumn field.chalages is in join is "inovice id " in invoice details table is repeting and there are unique invoice id given in payments deyails table . So now I need help that what to do to join both table and make only one table because this table I need to add in my final application and i dont want to put these both table there , i want only single tabel with all information from these both table
i have attached excel sheet wiht both table
Why do you need only one table? It doesn't matter for the front end if there's only one table or two properly associated tables. Just rename INVOICE_ID to [invoice id] and your two tables should be linked correctly.
It is not mandatory to join the tables into one table, you can have multiple tables which are linked properly. So rename the INVOICE_ID to common case(For example: Invoice_ID) in both the tables, then this tables will join automatically.
INVOICE_ID AS Invoice_ID,
[invoice id] AS Invoice_ID,
Hope this helps you.
If you have Many to Many join then records will be duplicated and sometimes some values will be duplicated, so better not to join those, including single table or multiple is not going to have much difference.
So what? There can be dozens of tables in the model. As long as they're properly associated that's not a problem. Anyway, you already know that you need to rename fields either to link or to join the tables.
i think my require solution was diffrent , let me explain again
my main motive is only i want to make single table from these two tbales. , because i dont want to put these 2 table in my final appication there are already more then 6-7 tables are there