# Displaying 1 row of data

**URL:** <https://forum.kirupa.com/t/displaying-1-row-of-data/233247>\
**Category:** Uncategorized\
**Created:** [July 21, 2007, 10:29pm UTC](https://forum.kirupa.com/t/displaying-1-row-of-data/233247 "2007-07-21T22:29:55Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ivanwright](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/ivanwright/32/119_2.png) [@ivanwright](https://forum.kirupa.com/u/ivanwright)\
**Post date:** [July 21, 2007, 10:29pm UTC](https://forum.kirupa.com/t/displaying-1-row-of-data/233247/1 "2007-07-21T22:29:55Z")

</div>

i’m sure this is the most elementary of questions / problem. but, here goes…

i have a database that has data in 2 tables. i want to pull 2 fields from one table and 1 field from another table with the field “patron\_id” being the primary key that is in both tables.

i want to have someone enter the “patron id” into a text box. at that point, the Patron’s First & Last name will appear along with one other piece of information.

what’s the query i would use?