Styjun

What is the range of a Drunken Monk's Redirect attack?

How would a lunar colony attack Earth?

Help me, I hate squares!

Gold Battle KoTH

Balancing Humanoid fantasy races: Elves

Why didn't General Martok receive discommendation in Star Trek: Deep Space Nine?

Translate the beginning of the blessing "Asher Yatzar"

Introduction to the Sicilian

Russian pronunciation of /etc (a directory)

How is char processed in math mode?

Why is “deal 6 damage” a legit phrase?

Why are we moving in circles with a tandem kayak?

Using Python in a Bash Script

integration of absolute value

Why was the Lobbying Transparency and Accountability Act of 2006 deemed too weak?

Rampant sharing of authorship among colleagues in the name of "collaboration". Is not taking part in it a death knell for a future in academia?

Create two random teams from a list of players

Why does Latex make a small adjustment when I change section color

May a hotel provide accommodation for fewer people than booked?

How to structure presentation to avoid getting questions that will be answered later in the presentation?

Was Donald Trump at ground zero helping out on 9-11?

Can I shorten this filter, that finds disk sizes over 100G?

What clothes would flying-people wear?

PCB design using code instead of clicking a mouse?

i think my where clause is wrong how to fix it

How can I prevent SQL injection in PHP?How to find all the tables in MySQL with specific column names in them?SQL join: where clause vs. on clauseHow do I limit the number of rows returned by an Oracle query after ordering?INNER JOIN ON vs WHERE clauseMySQL join with where clauseSQL Server: How to Join to first rowHow do I UPDATE from a SELECT in SQL Server?MySQL error code: 1175 during UPDATE in MySQL WorkbenchReset identity seed after deleting records in SQL Server

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

in this case there are 2 tables which is products and images table. what i want to do is select all the product from product table where condition(a column of product table) is "used" and inner join images using product-name(colomn of products and images table -foreign key)

i have tried using selct all, inner joint and where clause.

(
"SELECT * FROM products p "
where condition="used"

• "INNER JOIN images i "


• "USING ( product-name ) "

)

mysql sql where-clause

share|improve this question

asked Mar 26 at 22:33

s.am.is.am.i

1322 bronze badges

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  What is that??? What's with the bracket, double quote, the black thing before INNER JOIN and USING. How do you expect it to work? Have you even check MySQL documentation how to create a query?
  
  – Eric
  Mar 26 at 22:46
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Well said @Eric. Also product-name is product minus name. Welcome to SO @s.am.i. Precise questions get much better responses, don't be put off, keep asking but improve the clarity.
  
  – danblack
  Mar 26 at 23:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry for the mistakes...brackets are because of i am using it inside if statement..and that black thing was + i typed it as + but it appeared as black thing
  
  – s.am.i
  Mar 27 at 6:24
  

  
  
  
  

add a comment | 

1

in this case there are 2 tables which is products and images table. what i want to do is select all the product from product table where condition(a column of product table) is "used" and inner join images using product-name(colomn of products and images table -foreign key)

i have tried using selct all, inner joint and where clause.

(
"SELECT * FROM products p "
where condition="used"

• "INNER JOIN images i "


• "USING ( product-name ) "

)

mysql sql where-clause

share|improve this question

asked Mar 26 at 22:33

s.am.is.am.i

1322 bronze badges

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  What is that??? What's with the bracket, double quote, the black thing before INNER JOIN and USING. How do you expect it to work? Have you even check MySQL documentation how to create a query?
  
  – Eric
  Mar 26 at 22:46
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Well said @Eric. Also product-name is product minus name. Welcome to SO @s.am.i. Precise questions get much better responses, don't be put off, keep asking but improve the clarity.
  
  – danblack
  Mar 26 at 23:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry for the mistakes...brackets are because of i am using it inside if statement..and that black thing was + i typed it as + but it appeared as black thing
  
  – s.am.i
  Mar 27 at 6:24
  

  
  
  
  

add a comment | 

in this case there are 2 tables which is products and images table. what i want to do is select all the product from product table where condition(a column of product table) is "used" and inner join images using product-name(colomn of products and images table -foreign key)

i have tried using selct all, inner joint and where clause.

(
"SELECT * FROM products p "
where condition="used"

• "INNER JOIN images i "


• "USING ( product-name ) "

)

mysql sql where-clause

share|improve this question

asked Mar 26 at 22:33

s.am.is.am.i

1322 bronze badges

share|improve this question

asked Mar 26 at 22:33

s.am.is.am.i

1322 bronze badges

share|improve this question

asked Mar 26 at 22:33

s.am.is.am.i

1322 bronze badges

asked Mar 26 at 22:33

s.am.is.am.i

1322 bronze badges

asked Mar 26 at 22:33

s.am.is.am.i

1322 bronze badges

1 Answer
1

active

oldest

votes

2

When you get a syntax error, consult the manual on SELECT. WHERE clauses come after JOIN like:

SELECT * FROM products p
INNER JOIN images i USING ( `product-name` )
WHERE condition="used"

share|improve this answer

edited Mar 26 at 23:12

answered Mar 26 at 22:42

danblackdanblack

3,53811 gold badge44 silver badges2222 bronze badges

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55367136%2fi-think-my-where-clause-is-wrong-how-to-fix-it%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

2

When you get a syntax error, consult the manual on SELECT. WHERE clauses come after JOIN like:

SELECT * FROM products p
INNER JOIN images i USING ( `product-name` )
WHERE condition="used"

share|improve this answer

edited Mar 26 at 23:12

answered Mar 26 at 22:42

danblackdanblack

3,53811 gold badge44 silver badges2222 bronze badges

add a comment | 

2

When you get a syntax error, consult the manual on SELECT. WHERE clauses come after JOIN like:

SELECT * FROM products p
INNER JOIN images i USING ( `product-name` )
WHERE condition="used"

share|improve this answer

edited Mar 26 at 23:12

answered Mar 26 at 22:42

danblackdanblack

3,53811 gold badge44 silver badges2222 bronze badges

add a comment | 

When you get a syntax error, consult the manual on SELECT. WHERE clauses come after JOIN like:

SELECT * FROM products p
INNER JOIN images i USING ( `product-name` )
WHERE condition="used"

share|improve this answer

edited Mar 26 at 23:12

answered Mar 26 at 22:42

danblackdanblack

3,53811 gold badge44 silver badges2222 bronze badges

SELECT * FROM products p
INNER JOIN images i USING ( `product-name` )
WHERE condition="used"

share|improve this answer

edited Mar 26 at 23:12

answered Mar 26 at 22:42

danblackdanblack

3,53811 gold badge44 silver badges2222 bronze badges

answered Mar 26 at 22:42

danblackdanblack

3,53811 gold badge44 silver badges2222 bronze badges

answered Mar 26 at 22:42

danblackdanblack

3,53811 gold badge44 silver badges2222 bronze badges