View of two tables

Hello,
I purchased AllinOne Tools JX and want to create a view like you describe it.
My two tables are joomgallery and joomgallery_image_details.
At the Joomgallery table are fields like id, imagetitle, imagetext....
and at the joomgallery_image_details Table are id, details_key and details_value
this table looks a litle bit different to the first one:
for example:
The header of the table are:
id, details_Key, details_value
2, Length, 35
2, Width, 20
2, Striae, 12
3, Length, 25
3, Width, 22
3, Striae, 2
....

Both are connected by the fields ID.
What I tried is this text but I got an error 1060.

CREATE VIEW TestView AS
SELECT *FROM joomgallery t1, joomgallery_image_details t2

WHERE t1.ID = t2.ID

2.
From the "Joomgallery" table I create a table with imagetitle and imagetext.
So I want to link the field imagetitle from the table to the detail page of the joomgallery.
I tried it with customId and the text index.php?option=com_joomgallery&view=detail&id=@ID
but I got an error.

3.
I create a table with articels.
But now at the table are all articles shown. I want only articles of a specific categorie called "Diatomeen Steckbriefe" inkl. all subcategories should be shown.


Did anyone have an idea what I do wrong or can help?
Or how can I solve this.
Thanks

Hello,
thank you for your answer.
Yes, perhaps I was somewhat too naive, but I thought it would be a little bit easier to solve this...
1.
I tested it and got a result with 0 entries. No error message.
If I select the view with the fields at tablejx also empty.
Only if I create a view at the database their is an error message at the backend:
Warning: mysqli_close() [function.mysqli-close]: Couldn't fetch mysqli in /www/htdocs/.../.../libraries/joomla/database/driver/mysqli.php on line 210
But I asked my provider at this time.

2.
Thanks alot now it works.....
I selected a wrong column before.

3.
Ok, if I cannot solve 1., so I think I should not solve this point at the moment ....


Thanks you for your time and help...

Hello,
so I found a friend he has coded a solution that work for one table.
But one question I have about the link function.
At the table one column will be shown (title) and this will be linked. This are different article of joomla.
For a correct link I use the "cid" for the link column and as the link column type I select
1. URL
2. Article ID
If I choose 1. the correct site will be shown with the whole breadcrumbs /Home/Steckbriefe/....) but the site would be shown as a content (Article) of the Homepage, all modules of the Homepage (Homesite) are shown right and left of the article. The modules are only selected for the home-Site and would not visible at another site (menu assignment only home marked)

If I choose 2. the article will be shown as a own site but the breadcrumbs will not be shown, only home is visible.

Do you have a idea?
Regards
Maggi

Thank you for your answer, but I am sorry I didnot understand it correct what I have to config.....
What I have is a view of articles (Joomla content) from two different categories with subcategories.
The view has follow columns: cid, catid, kid, parent_id, k_title, path and title.
Only the Title Column is selected to show this a the table (Title = the name of the article).
This Name (title) should be linked to the article itself. So it is possible to link the title to the article, that also the breadcrumbs show the right navigation? How can I solve this when I use the customID link option?
Thank you for your help.
Regards
Maggi