<div>
It looks like all fields in the Grid come from the first table.<br />
<br />
Is that correct?
</div>


It looks like all fields in the Grid come from the first table.

Is that correct?

<div>
No. I would like to join with vendorName in each table .
</div>


No. I would like to join with vendorName in each table .

<div>
VendorName is not in the Grid, but you would like to include it, right?<br />
<br />
and<br />
<br />
Is join field vendor (Vendor #)?
</div>


VendorName is not in the Grid, but you would like to include it, right?

and

Is join field vendor (Vendor #)?

<div>
<div class="content wysiwyg-content">
Hi all:<br />
I've one table consists of 6 column (xdate, trno, servtype, vendor, customer, usersign). <br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/10_w41/681348/pic1.png" target="_blank" title="first table (14 KB)"><img alt="first table" class="file-block lazyload" style="max-width: 495px;" data-src="https://filedb.experts-exchange.com/incoming/2013/10_w41/681348/pic1.png" /></a><br />
and 3 vendors table (tktvendor, bookingvendor, insuranceVendor). <br />
<br />
i would like to join between the first table and the three vendors table according to field &quot;servtype&quot; value <br />
if &nbsp;servtype=1 i would like to join tktvendor<br />
if &nbsp;servtype=2 i would like to join bookingvendor<br />
if &nbsp;servtype=3 i would like to join insuranceVendor
</div>
</div>


pic1.png

Hi all:
I've one table consists of 6 column (xdate, trno, servtype, vendor, customer, usersign). 



and 3 vendors table (tktvendor, bookingvendor, insuranceVendor). 

i would like to join between the first table and the three vendors table according to field "servtype" value 
if  servtype=1 i would like to join tktvendor
if  servtype=2 i would like to join bookingvendor
if  servtype=3 i would like to join insuranceVendor

query Syntax

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.