<div>Hi All</div>
<div>I have custom tables in mysql database. I want to have a view, where I want to show the data from custom tables in a tabular format with certain conditions.</div>
<div> </div>
<div>Example:</div>
<div>
<table style="WIDTH: 631pt; BORDER-COLLAPSE: collapse" border="0" cellspacing="0" cellpadding="0" width="840">
<colgroup>
<col style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2084" width="57">
<col style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2450" width="67">
<col style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width="79">
<col style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width="85">
<col style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 3401" width="93">
<col style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3291" width="90">
<col style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width="84">
<col style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width="72">
<col style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 4022" width="110">
<col style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3766" width="103">
<tbody>
<tr style="HEIGHT: 46.5pt" height="62">
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #0070c0 1.5pt solid; BACKGROUND-COLOR: #dbe5f1; WIDTH: 43pt; HEIGHT: 46.5pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" class="xl70" height="62" width="57">
<strong><font color="#ff0000" face="Calibri">UID</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 50pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" class="xl71" width="67"><strong><font color="#ff0000" face="Calibri">Name</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 59pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" class="xl71" width="79"><strong><font color="#ff0000" face="Calibri">Email ID</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 64pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" class="xl71" width="85"><strong><font color="#ff0000" face="Calibri">Alternate <br>
Email ID</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 70pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" class="xl71" width="93"><strong><font color="#ff0000" face="Calibri">Phone number</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 68pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" class="xl71" width="90"><strong><font color="#ff0000" face="Calibri">Alternte <br>
phone <br>number</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 63pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" class="xl71" width="84"><strong><font color="#ff0000" face="Calibri">DOB</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 54pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" class="xl71" width="72"><strong><font color="#ff0000" face="Calibri">Years of <br>
experience</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 83pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #ece9d8" class="xl71" width="110"><strong><font color="#ff0000" face="Calibri">Preferred work location</font></strong></td>
<td style="BORDER-BOTTOM: #0070c0 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; WIDTH: 77pt; BORDER-TOP: #0070c0 1.5pt solid; BORDER-RIGHT: #0070c0 1.5pt solid" class="xl72" width="103"><strong><font color="#ff0000" face="Calibri">Highest Qualification</font></strong></td>
</tr>
<tr style="HEIGHT: 30.75pt" height="41">
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #0070c0 1.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 43pt; HEIGHT: 30.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl68" height="41" width="57"><font face="Calibri">1</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 50pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="67"><font face="Calibri">Austin</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 59pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl66" width="79"><a href="mailto:austi@yahoo.com"><font face="Calibri">austi@yahoo.com</font></a></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 64pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl66" width="85"><a href="mailto:au@rediffmail.com"><font face="Calibri">au@rediffmail.com</font></a></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="93"><font face="Calibri">123456789</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="90"><font face="Calibri">987654321</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl67" width="84"><font face="Calibri">1/15/1975</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="72"><font face="Calibri">10</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 83pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="110"><font face="Calibri">Texas</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 77pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #0070c0 1.5pt solid" class="xl69" width="103"><font face="Calibri">B.E (Electrical)</font></td>
</tr>
<tr style="HEIGHT: 30pt" height="40">
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #0070c0 1.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 43pt; HEIGHT: 30pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl68" height="40" width="57"><font face="Calibri">2</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 50pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="67"><font face="Calibri">John</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 59pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl66" width="79"><a href="mailto:john@yahoo.com"><font face="Calibri">john@yahoo.com</font></a></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 64pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl66" width="85"><a href="mailto:jo@rediffmail.com"><font face="Calibri">jo@rediffmail.com</font></a></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="93"><font face="Calibri">3333333333</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="90"><font face="Calibri">5555555555</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl67" width="84"><font face="Calibri">2/16/1989</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="72"><font face="Calibri">6</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 83pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="110"><font face="Calibri">Washington DC</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 77pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #0070c0 1.5pt solid" class="xl69" width="103"><font face="Calibri">BSC</font></td></tr>
<tr style="HEIGHT: 30pt" height="40">
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #0070c0 1.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 43pt; HEIGHT: 30pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl68" height="40" width="57"><font face="Calibri">3</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 50pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="67"><font face="Calibri">Russel</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 59pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl66" width="79"><a href="mailto:r@yahoo.com"><font face="Calibri">r@yahoo.com</font></a></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 64pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl66" width="85"><a href="mailto:r@rediffmail.com"><font face="Calibri">r@rediffmail.com</font></a></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 70pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="93"><font face="Calibri">777777777</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 68pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="90"><font face="Calibri">99999999</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 63pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl67" width="84"><font face="Calibri">3/8/1987</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="72"><font face="Calibri">8</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 83pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class="xl65" width="110"><font face="Calibri">Seoul</font></td>
<td style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 77pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #0070c0 1.5pt solid" class="xl69" width="103"><font face="Calibri">MSC</font></td></tr>
</tbody></colgroup></table></div>
<div> </div>
<div> </div>
<div> </div>
<div>Lets say, in a view I want to show data from this table with a condition.</div>
<div>Let the condition is "people who work in Texas".</div>
<div> </div>
<div>I have now basic knowledge on views. Can somebody give me a step wise help , how to acheive this.</div>
<div> </div>
<div>Regards</div>
<div>Austin</div>
<div> </div>