Welcome Guest ( Log In | Register )



2 Pages V  < 1 2  
Reply to this topicStart new topic
> Linking Two Tables
ginginca
post Aug 31 2006, 11:11 AM
Post #11


Premium Member
Group Icon

Group: Members
Posts: 250
Joined: 6-July 06
From: The net (or at least that's what my family says)
Member No.: 14,330



QUOTE(SP Rao @ Aug 31 2006, 01:58 AM) *

Well, as ginginca was asking for some guidance, there are a lot of stuff in the web. Somehow I feel that you don't need to search particularly for MySQL tutorials alone. It's better you learn the basica of SQL first. (May be little bit about RDBMS concepts).

Now, there are million sites on net which will provide you information about SQL. The one which is particularly good for beginners is http://sqlcourse.com/. This site offers online interactive tutorial where you can test what you are learning too.

Moreover, you will get info and updates on almost all well known databases MySQL, Oracle, MS SQL etc.
I think this site will definitely help you in learning the SQL basics.

You may also try W3Schools tutorials for SQL SQL Tutorial

For RDBMS concepts and data modelling, any google search will help you.
Happy programming biggrin.gif


Thanks for all the feedback!
Go to the top of the page
 
+Quote Post
masterio
post Sep 24 2006, 03:41 AM
Post #12


Newbie [ Level 2 ]
Group Icon

Group: Members
Posts: 21
Joined: 24-September 06
Member No.: 16,119



Hi guys, I have some question for you. From many articles that I've read. I only found about joining two tables. But I didn't find about joing more than two tables, three tables, and even more!.

Is joining more than two tables same as joining more that 2 tables?. I little confuse about it. If joining 2 tables we simply using query like this:

CODE

SELECT table1.column1, table1.column2, table1.column3 FROM table1, table2 WHERE table1.column2='VALUE'


Help is very appreciate! biggrin.gif
Go to the top of the page
 
+Quote Post
iGuest
post May 2 2008, 10:54 AM
Post #13


Newbie [ Level 1 ]
Group Icon

Group: Members
Posts: 0
Joined: 1-November 07
Member No.: 25,869



How to link two tables in sql using primary and foriegn key

-reply by shofiya
Go to the top of the page
 
+Quote Post

2 Pages V  < 1 2
Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Recover Tables From A MySQL .frm File(8)
  2. Creating Tables In MySQL On Home Comp(8)
  3. User Priveileges Vs. Tables Vs Rows(1)
  4. Updating A Database's Tables(10)
  5. MySQL, Multiple Tables(24)
  6. (help With Sql And Php)retrive Datas From Realted Tables And Display Them!(4)
  7. Script Tables On Sql Server Compact(0)
  8. Mysql Problem(1)
  9. Mysql Multiple Tables(1)


 



- Lo-Fi Version Time is now: 11th October 2008 - 08:47 PM