Table relation graph, to see all the entities between tables...

[LanTheSweeper]

Hi

I would like to know is it possible to get more informations about the existing tables in LanSweeper?
The help file is to ruffe and I would like to know how I could join table really easy..;-)
It would be perfect to get a chart so that it would be easier to create some reports. The other problem for me was to find out what tables are linked so that I can join them and get the output I like and who makes sense.
Another problem was with LEFT or RIGHT JOINS, is there any way to use them, because it is not working for me in the moment...?

Thanks in advance
Michael

[Hemoco]

Can you post a "problem" sql query please.

[LanTheSweeper]

Sorry I relaised LEFT OUTER JOIN or RIGHT OUTER JOIN
NOT left join or right join as SQL statements 😉