CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> General -> Forum Comments

 SQL select statement fro multiple tables

Print topic Send  topic

Author Message
Posted: 12/10/2005, 2:09 AM

Hi there
I need to select columns from multiple tables by performing a join.

How to do it
Walter Kempees
Posted: 12/10/2005, 4:55 AM


You have to be more specific:
- Do you already know how to do joins in SQL?
- do you already know the different type of joins in SQL?
- do you know how to do SQL in CCS, hoe to use VQB
- Whate and where do you need help with exactly.
Please also state version of CCS and Language/SQL version, even post your
qquestion in the language specific forum.
Snapshot of table definition might be helpful too.

After that I know everybody will be willing to help.

Have a great weekend,

"sheetal" <sheetal@forum.codecharge> schreef in bericht
> Hi there
> I need to select columns from multiple tables by performing a join.
> How to do it
> ---------------------------------------
> Sent from YesSoftware forum

Posted: 12/24/2005, 2:24 AM

what are the types of select statement

Posts: 5971
Posted: 12/24/2005, 11:43 AM

Different databases may support different SQL syntax and select statements. Take a look at
Peter R.
YesSoftware Forums Moderator
For product support please visit
View profile  Send private message
Sumit Kumar
Posted: 02/17/2006, 3:07 AM

:-{} Use UNION statement
SELECT * from t1 UNION * from t2 ......:-{}

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Internet Database

Visually create Web enabled database applications in minutes.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.