Member Avatar for mrhankey

hi,

i have in a table"visitdate1, visitdate2, visitdate3 and visitdate4"
i also have in this table address fields of "housenumber, street, city, zip"

i want to run a query which shows me the amount of visits to a house. should these be stored in different tables?

thanks

  • 2 Contributors
  • 4 Replies
  • 86 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for smantscheff

This looks like a somewhat awkward table setup. You'd better have one table for visitdates and one for addresses.

Member Avatar for mrhankey

thanks, i did think of this however i was unsure how i would impliment this. think you maybe right though.

Member Avatar for mrhankey

i have now changed this, and store the visits in a seperate table.

so in the first table i just store the first date of visit then any other visits in the visits table.

question is what query (join) would i use to determine what jobs were done and completed on fisrt visit? so the id wont be present from the jobs table in the visits table?

thanks

Member Avatar for smantscheff

Why don't your store all visits in the visit table? Why do you store the first visit date separate from the others? How do you store jobs? Show the table structure of those tables.

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.