can you join 3 or more tables

Answer 1

yes

Answer 2

Yes. you can join many tables.
ex:
select *
from a inner join
b on a.field1 = b.field1
inner join
C on a.field2 = C.field2

Answer 3

yes

Answer 4

just by simply adding comma (, )

Answer 5

yes. there are 3 types of joins. inner, left outer and right outer. all these types can be used to join multiple tables..

Answer 6

We can join n number table but we have to vigilant about relationship of primary keys in tables

Answer 7

I believe so .

Answer 8

why not?

Answer 9

yes

Answer 10

yes

Answer 11

yes

Answer 12

yes

Answer 13

yes

Answer 14

yes we can join more than 2 tables

Answer 15

yes

Answer 16

yes

Answer 17

I think this is gonna work :select custid, name, product, price from customer_detail ,mall, theater where custid=mall. custid

Answer 18

Surely

Answer 19

you can join as many tables as you want

Answer 20

yes