Multiple tables selection while using Freehand SQL

[manna_das]

Dear All,

How to select multiple tables in Freehand Sql. I am not able to select multiple tables.

Kind Regards

Manna Das

[manna_das]

Hello thanks for the reply. I tried a lot but its not working, the query only reads the first line, even if i change the line it does not work

Kind Regards

Manna Das

[Former Member]

Could you paste here the entire query?

[manna_das]

Hello Bartlomiej,

This is the entire query. Pasted above.

Kind Regards

Manna Das

[Former Member]

I'm guessing it shows you only the fields you've selected from Account. Try adding the columns from Contact and from Opportunity for example

Select col1.Account col2.Account col1.Contact col1.Opportunity from Account

Join Contact...

Join Opportunity...

Just like in the tutorial I've sent you. They're example is like this:

SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate

FROM Orders

INNER JOIN Customers

ON Orders.CustomerID=Customers.CustomerID

Note that they use fields from the joined tables after the word "SELECT" in the select statement.

Let me know if this solves your problem.

Regards,

Bartłomiej.