Query will duplicate records

[funkygoorilla]

I have multiple queries working with one table, that when ran, will show a single row of data twice. I have verified that there is only one applicable row in this table, and have even deleted all information in it and entered only this one row worth of information. But, when I run a query against it, the query returns duplicate results. Can anyone give me a hint of why this may be happening?
Thanks,
FunkyG

[stmoong]

You can use DISTINCT in your query to return unique row based on your selected columns.

SELECT DISTINCT col1, col2 FROM table1 WHERE ...

Possible reason might be col3, which is not queried, would have different values when you run the SELECT statement. If you want to check, you could do a SELECT * FROM table1 WHERE ...

[funkygoorilla]

Hi, thanks for your reply. I think I figured it out. I had a improperly place foreign key, and it was making my query return double results. However, your post will be good to reference in the future. Thanks again!
FunkyG

[stmoong]

You're welcome.