Member Avatar for xanawa

Hi,

I have a database with two tables

tblCustomer
- Name string
- Surname string
- ID Card string (PK)
- CityID int (FK)


tblCity
- ID int (PK)
- Name string


Now i want to show all the customer details but i would like to show the name of the city not the ID. How can i do that?

  • 2 Contributors
  • 1 Reply
  • 41 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by ddanbe
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.