Pre-purchase question

I have two tables in my joomla database with data that I wish to present in a joomla article. One table has 3 text fields i need (and an id field in common with the other table), and another table has one data field that I need.

Firstly, can I link 2 tables in Table JX?

Secondly, the data field in the second table is in comma delimited form. I need each data element in the comma delimited field separated into its own column. Is that possible?

Thanks in advance.

Hi,
Not yet.

This is possible with SQL. You can create View and display view with Table JX. If you need help, send us mail with details.

Example:

CREATE VIEW Something AS
SELECT substring_index(field,', ', 2), substring_index(field,', ', -2)
FROM Table