CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> General -> Forum Comments

 SQL select statement fro multiple tables

Print topic Send  topic

Author Message
sheetal
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

Sheetal,

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,

Walter
"sheetal" <sheetal@forum.codecharge> schreef in bericht
news:17439aa96496436@news.codecharge.com...
> Hi there
> I need to select columns from multiple tables by performing a join.
>
> How to do it
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

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

what are the types of select statement
peterr


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

Different databases may support different SQL syntax and select statements. Take a look at http://www.google.com/search?hl=en&q=sql+select+statement
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
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 http://support.yessoftware.com.

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login


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