"Connect 2 tables" (#2608128) / TMS-Plugins

Rene started the conversation

November 22, 2020 at 10:52am

I have 2 different tables with the same number of columns. How can I connect them?

2,572

Aleksandar replied

November 23, 2020 at 9:37pm

Hello Rene

Thank you for your purchase.

I'm sorry, I can't understand what you're asking. Do you want to join two tables into one, or connect values from one table with another?

Please explain to me what you're trying to do, and I'll try to help you out.

Kind Regards,

Aleksandar Vuković
[email protected]

Rate my support

You can try wpDataTables add-ons before purchasing on these sandbox sites:

Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

Rene replied

December 7, 2020 at 12:52pm

Hello

yes i want to connect values from one table with another.

Example:

Table 1: Table 2:

Maschine Time Maschine Price

A 34 A 100

B 50 B 150

Result:

Maschine Time Price

A 34 100

B 50 150

Thank you very much.

Best regards

Rene

2,572

Aleksandar replied

December 8, 2020 at 10:18am

Hello again Rene

Something like this is best done with SQL query based tables. If you're not that familiar with SQL, you can use our query constructor.

Another option would be to use foreign keys, but in that case you would need to manually select the data for each column and row.

Kind Regards,

Aleksandar Vuković
[email protected]

Rate my support

You can try wpDataTables add-ons before purchasing on these sandbox sites:

Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

Rene replied

December 8, 2020 at 11:40am

Hello,

i already had a solution with the "with" command, unfortunately WP Data tables does not take a "with" command.

Maybe you can give me an example?

I will look further.

Thanks again

Best regards

Rene

2,572

Aleksandar replied

December 9, 2020 at 12:49pm

I'm not sure about this, Rene, but you can try:

SELECT table1.`Machine`,
       table1.`Time`,
       table2.`Price`
FROM table1
  INNER JOIN table2
     ON table1.`Machine` = table2.`Machine`

Of course, you need to modify table1 and table2 so it represents the table name in the database, and also make sure the headers are correct.

Kind Regards,

Aleksandar Vuković
[email protected]

Rate my support

You can try wpDataTables add-ons before purchasing on these sandbox sites:

Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

Comments